batch statement

英 [bætʃ ˈsteɪtmənt]

美 [bætʃ ˈsteɪtmənt]

网络  成批处理语句

计算机

双语例句

• The batch update feature improves the performance of a single statement that is executed multiples times, with multiple value settings.
  通过设置多个值，批量更新特性提高了需要多次执行的语句的性能。
• For example, batch applications that must execute many update operations serially are often better off executing SQL statement in sequence without all the extra object hydration.
  例如，必须连续执行多个更新操作的批处理应用程序通常能够更好地依次执行SQL语句，而无需所有额外的对象交互。
• But a statement object submits different SQL statements to batch, while prepared statement submits a set of parameters to batch.
  但语句对象提交不同的SQL语句进行批处理，而预置语句提交的是一组参数。
• An error that terminates a batch and generates an internal rollback deallocates all cursors that were declared in the batch containing the error statement.
  终止批处理并生成内部回滚的错误将释放在包含错误声明的批处理中声明的所有游标。
• If a subscription request is made for a batch or stored procedure, a separate subscription request is made for each statement executed within the batch or stored procedure.
  如果发出批处理或存储过程订阅请求，则会针对批处理或存储过程内执行的每个语句发出单独的订阅请求。
• When using default result sets, an application can execute any Transact-SQL statement or batch, but it can only have one outstanding statement on a connection.
  使用默认结果集时，应用程序可以执行任何transact-sql语句或批处理，但它只允许一个连接中有一个未完成的语句。
• For batch updates, a collection parameter is used vertically to execute an SQL statement more than once, with different parameter values each time.
  对于批量更新，需要使用一个集合参数多次执行一条SQL语句，每次执行时使用不同的参数值。
• If the batch is compiled and the second statement then fails while running, the results of the first statement are not affected because it has already executed.
  如果批处理经过编译，并且第二条语句在运行时失败，则第一条语句的结果不会受到影响，因为已执行了该语句。
• When batches are used, the database context is determined by the batch established by using the use statement.
  使用批处理时，数据库上下文由使用use语句建立的批处理决定。
• Number of characters into the currently executing batch or stored procedure at which the currently executing statement ends.
  在当前正在执行的批处理或存储过程中，指示当前正在执行的语句结束位置的字符数。